/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-29 17:33:56
*/


-- ----------------------------
-- Table structure for tb2535
-- ----------------------------
DROP TABLE [dbo].[tb2535]
GO
CREATE TABLE [dbo].[tb2535] (
[DivisionID] varchar(20) NOT NULL ,
[DepartmentID] varchar(20) NOT NULL ,
[TeamID] varchar(20) NOT NULL ,
[TeamName] nvarchar(50) NULL ,
[Disabled] tinyint NOT NULL DEFAULT((0)),
[CreateUserID] varchar(20) NULL ,
[CreateDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[Notes] nvarchar(250) NULL ,
[Notes01] nvarchar(250) NULL 
)


GO
-- ----------------------------
-- Indexes structure for table tb2535
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb2535
-- ----------------------------
ALTER TABLE [dbo].[tb2535] ADD PRIMARY KEY NONCLUSTERED ([DivisionID], [DepartmentID], [TeamID]) WITH (FILLFACTOR=90)
GO

-- ----------------------------
-- Records of tb2535
-- ----------------------------
INSERT INTO [dbo].[tb2535] ([DivisionID], [DepartmentID], [TeamID], [TeamName], [Disabled], [CreateUserID], [CreateDate], [LastModifyUserID], [LastModifyDate], [Notes], [Notes01]) VALUES (N'HPCNB2013', N'KD', N'KD1', N'KINH DOANH KV MIEN TAY', N'0', N'admin', N'2011-07-29 17:57:18.920', N'admin', N'2011-07-29 17:57:18.920', null, null)
GO
GO
INSERT INTO [dbo].[tb2535] ([DivisionID], [DepartmentID], [TeamID], [TeamName], [Disabled], [CreateUserID], [CreateDate], [LastModifyUserID], [LastModifyDate], [Notes], [Notes01]) VALUES (N'HPCNB2013', N'KT', N'THANHTOAN', N'TO THANH TOAN', N'0', N'admin', N'2011-07-22 11:59:28.577', N'admin', N'2011-07-22 11:59:28.577', null, null)
GO
GO


